UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's+BpB3c9Bz42WSg9wGKmX5jFlm8bauU57kjzxh1ccSw='
WHERE
key_id = '0e13df441d7ed28ab4c9ad85ff6a4d3a6a8731f6e9af1b1f0f77610da033b8ab'
AND (
token = 's+BpB3c9Bz42WSg9wGKmX5jFlm8bauU57kjzxh1ccSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)