UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nnrkX913HyRhAhq9ya1JTH5ZQb1U5SErN0DWTyIWDTA='
WHERE
key_id = 'e9b78a28bfca58763aa74ee23bd5d8edbab7c71e8b8d2e962a635ee6b3fdb436'
AND (
token = 'nnrkX913HyRhAhq9ya1JTH5ZQb1U5SErN0DWTyIWDTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)