UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBVEB0GMzHz1nPWkVV8/glzVQ1OrSAo7IYhmOlpFwX4='
WHERE
key_id = 'a5ee3b5a7b45fa42947aee2cfd687abad7d2d3d66867c215aa3c1dcde2378c35'
AND (
token = 'pBVEB0GMzHz1nPWkVV8/glzVQ1OrSAo7IYhmOlpFwX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)