UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DQ+VI+N0vgcImytpG9/Q2RmGdAVs8b9+z6x++U1cvyc='
WHERE
key_id = '8ba5e98662586617b2012cc95af529f5939de24e9f5d600466d8700b41d03ed7'
AND (
token = 'DQ+VI+N0vgcImytpG9/Q2RmGdAVs8b9+z6x++U1cvyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)