UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QjPjf+O7SdN780aaLYMP3nrsQUzZHlvKNMfNDbIc68='
WHERE
key_id = 'c2a6a7167ae08b95d253801e3f5d1471adf139fa0054ab7152f70b2b6822db35'
AND (
token = '6QjPjf+O7SdN780aaLYMP3nrsQUzZHlvKNMfNDbIc68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)