UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4Txt9ncWe7SZdoGyFVWTXg11873Hg3U6+QuYfgVcS0='
WHERE
key_id = '1f2d74aaad0f7283b6b05c448e816ac36ef649a1f29dde2f8b0729f46bea860c'
AND (
token = 'a4Txt9ncWe7SZdoGyFVWTXg11873Hg3U6+QuYfgVcS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)