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