UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZQNSebtvNt+6gSHGtECduDDI0UN7AoS31chLu9sIgA='
WHERE
key_id = '774c5818e347b453caee4404b940cddf17a84af1770ca5393e968140bed31b14'
AND (
token = 'pZQNSebtvNt+6gSHGtECduDDI0UN7AoS31chLu9sIgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)