UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7mCh12ZWnNP3b8pbPDofZyWqaqrC8vfSwRwzNsxRDM0='
WHERE
key_id = '02670f6beaa69ea22ec02b03207e9a99ca8d0c2c993ea65487bbb7a5cb8ed6b9'
AND (
token = '7mCh12ZWnNP3b8pbPDofZyWqaqrC8vfSwRwzNsxRDM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)