UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lUjGzG6vHVM+ZVKM5O7+q+/+BpXUzEnBtUs4zB3tKM='
WHERE
key_id = 'aae3d7e8f30e391509c151183870866451ce41201b2f26859e3c3d4d37b0e143'
AND (
token = '8lUjGzG6vHVM+ZVKM5O7+q+/+BpXUzEnBtUs4zB3tKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)