UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bo+teGmpCgH3ajIEl50M78UczeOjr+UvyIM4MZEHnKY='
WHERE
key_id = 'e0d4b2ca582329e8558ad30f53ffe2521fd57a2d0c670f79df5b37edaf0540c8'
AND (
token = 'Bo+teGmpCgH3ajIEl50M78UczeOjr+UvyIM4MZEHnKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)