UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tLaDWqtX50o9dbu42SVpA7KyfxjcU/htWkVINwd1lX4='
WHERE
key_id = '768ffc2ca3d7613e93e5e120e1074236ec1f6e91847408d16f3d02e3ac348c9c'
AND (
token = 'tLaDWqtX50o9dbu42SVpA7KyfxjcU/htWkVINwd1lX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)