UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YQ/c6S3E4Eq7puBVp07u/rXdGOtlVIjLe65Rm6WynjM='
WHERE
key_id = 'ca53e3c550031c33281062b0f2402f62520f949d0e2a49ef5a4312967cafe534'
AND (
token = 'YQ/c6S3E4Eq7puBVp07u/rXdGOtlVIjLe65Rm6WynjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)