UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9anFAafF/J46tECdHD1hkQ+jMa3Di3iXpn1rPtmSFs='
WHERE
key_id = '8814b47596018c8d5ee32e6336691045db1bc3a809af4f056a4c798606f4727d'
AND (
token = 'r9anFAafF/J46tECdHD1hkQ+jMa3Di3iXpn1rPtmSFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)