UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dbXGct1/OneJi1iP/oB9Tde1EPdNicm9m6QHhLOyhgM='
WHERE
key_id = 'a8bcd2a8363a675a488fc9b08d9a383ee90c0c6a1e55506b77da1b56f43e663f'
AND (
token = 'dbXGct1/OneJi1iP/oB9Tde1EPdNicm9m6QHhLOyhgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)