UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4b1xtDIVCDL5eX9Z5e/7WzRokcaqdrpyLyj7XggMRA='
WHERE
key_id = '92af5e3020f022d91c012560d7f76739bb3bf39ec8539a6f85d8a3b2f1255871'
AND (
token = 'D4b1xtDIVCDL5eX9Z5e/7WzRokcaqdrpyLyj7XggMRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)