UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9G1sE1rys6PdZjCskuPyGtASlHAPx+KPVjD1Liy0CCg='
WHERE
key_id = '42b6d5be5a029d074decb7d5f16bff0af1ab2c082881eb63ca4e620c8d35c744'
AND (
token = '9G1sE1rys6PdZjCskuPyGtASlHAPx+KPVjD1Liy0CCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)