UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hs47Ukl2yrklOPlQ1ZbYqHFVzdZ0oBkY0LqW1OTsrBo='
WHERE
key_id = 'c12daaedc63b61c3c40d50a77cb59bee57f5766c4d4c2033284fafd7924488f5'
AND (
token = 'Hs47Ukl2yrklOPlQ1ZbYqHFVzdZ0oBkY0LqW1OTsrBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)