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