UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gAJwhiNPrQUL+t/o2I99v+5cpTcrp1/IVvfji1/ylmI='
WHERE
key_id = '65344fad518ec4e49adfbffd55fc7cc588da882bbc9744ec4caa39db27ee8e14'
AND (
token = 'gAJwhiNPrQUL+t/o2I99v+5cpTcrp1/IVvfji1/ylmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)