UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9qU5s5tM8L5BRqcb0INmMy0cuNgYlTlHg8bLVzMCdA='
WHERE
key_id = 'ebb0657bf0373502c10c86d7d9fc7cf4fdc283cd8bd012ede78a821801d46128'
AND (
token = 'n9qU5s5tM8L5BRqcb0INmMy0cuNgYlTlHg8bLVzMCdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)