UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B3bQ91Xtcg60P6Epc73xcEBchHKi76ysXjgOOCwlJMQ='
WHERE
key_id = '31027a130b8c2bb6266668998093b00b710487fe6eb735e871fb34d52fa81d79'
AND (
token = 'B3bQ91Xtcg60P6Epc73xcEBchHKi76ysXjgOOCwlJMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)