UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHEnVBmHT4LgwMkj6d7OHgVh/vPd6duECd4c+ukuCbg='
WHERE
key_id = 'c15633d63fc9ad5cc5309ed54eb62e97f6feabc9579fa62c6de6a54bd5fc79dc'
AND (
token = 'ZHEnVBmHT4LgwMkj6d7OHgVh/vPd6duECd4c+ukuCbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)