UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mmPnBsmaeO+pQSS29I3glLuyQR+tpqhMw0L7ZIWv7Ss='
WHERE
key_id = 'bbefdd3f7470c59b758140abf867328790e8565fc168380b19d1b1265840a5df'
AND (
token = 'mmPnBsmaeO+pQSS29I3glLuyQR+tpqhMw0L7ZIWv7Ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)