UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5vdcAxQlipxtUbFCcr60rdUEZ4IePYmXvTn2Qb4asAU='
WHERE
key_id = 'f31b14d5ae8ca3896018f5f3146e9e7238d861bd9b8bdabe8588cb30d836553a'
AND (
token = '5vdcAxQlipxtUbFCcr60rdUEZ4IePYmXvTn2Qb4asAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)