UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiZgGUE1GfTXIOyjnWx02t8ps7iRs3WZVwtavW3pTkU='
WHERE
key_id = '05239f196a32efb47957e6c5ad56956b9647ec4f42fe8eb9790779ab8f2b4435'
AND (
token = 'qiZgGUE1GfTXIOyjnWx02t8ps7iRs3WZVwtavW3pTkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)