UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hrLpswjsKSJ8aY7RHCVnKrJquvBAmY0URbRTzSnn24U='
WHERE
key_id = '2a3c9e6c7682b8476d4a01bda2eee117114cca2357d46b3dba0a8a682c79e3db'
AND (
token = 'hrLpswjsKSJ8aY7RHCVnKrJquvBAmY0URbRTzSnn24U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)