UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIsHXZ9SjgjMSrqcj7YEAn+k6cAYeREDMPPbrezfVkc='
WHERE
key_id = '1346630c73c707e14f3bc9ae50b775899c844a148d7d5db652d7608341ea62bc'
AND (
token = 'gIsHXZ9SjgjMSrqcj7YEAn+k6cAYeREDMPPbrezfVkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)