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