UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TnXE7rpIn/BVyvyy0UUJO9TssdSpB8HLbno2J8WkdSo='
WHERE
key_id = 'fe277d22b382d2fd7ba380534f19393af6a000487de311340c9ea194d3df8705'
AND (
token = 'TnXE7rpIn/BVyvyy0UUJO9TssdSpB8HLbno2J8WkdSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)