UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lhwnrfP/v+fpAX8ULXZR1Hg/U7gU7cIZZ4BXlgh3gwE='
WHERE
key_id = 'f747db9964a8b31b6530c88bce7dc21c640c0f452eabca7ad194fdb144a5b367'
AND (
token = 'lhwnrfP/v+fpAX8ULXZR1Hg/U7gU7cIZZ4BXlgh3gwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)