UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FprmN0w7R9lbD8TuMNoogyN9aqqviLtKG8qaM049upc='
WHERE
key_id = '6d0f97ed450f9cae4db7a093ae47e8d4b753bb295dd46f568e7628d6c5ed7640'
AND (
token = 'FprmN0w7R9lbD8TuMNoogyN9aqqviLtKG8qaM049upc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)