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