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