UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpsh8aShm+n5RPo+COPIG5Cn0D+wv/NzbQieo6/jcFQ='
WHERE
key_id = 'ca22e33b6fd5cee301765ae44c2f555ac83de1a47e816e290e158d0543b71ee9'
AND (
token = 'hpsh8aShm+n5RPo+COPIG5Cn0D+wv/NzbQieo6/jcFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)