UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZEsKITY+BUCa/16FWg9LXPF/pV5oOPEqoByvrFXtDw8='
WHERE
key_id = '7d4c5379c6fcc6b4961c9495cf4ad545a4d1e54bb3d7428155d3176f81350d29'
AND (
token = 'ZEsKITY+BUCa/16FWg9LXPF/pV5oOPEqoByvrFXtDw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)