UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TKVqW7NnW/ILyxVsc2g2N5nGus3URh2noP3Si6vcSoI='
WHERE
key_id = '33e865e38697be799db7d5367b56893ef2b99f2755e301d84dc38705b4f63ea3'
AND (
token = 'TKVqW7NnW/ILyxVsc2g2N5nGus3URh2noP3Si6vcSoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)