UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uSgO1Qq7zn/j/v8KHBD5FiYwgo7We57/U56A+QRtc5w='
WHERE
key_id = '433cfee8a8e0fe9edf8b4c516f149bb788c99d418ea86ae7d6c83cdffbc5de0a'
AND (
token = 'uSgO1Qq7zn/j/v8KHBD5FiYwgo7We57/U56A+QRtc5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)