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