UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DTmPF8PfIdYTH7ZQKZ1IDMJAAaDiH8g3Bu3erMSHV2I='
WHERE
key_id = '314fc53172968160fda214bc53d7cd07f4324f1836e82f1fa754f79c8f5d7195'
AND (
token = 'DTmPF8PfIdYTH7ZQKZ1IDMJAAaDiH8g3Bu3erMSHV2I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)