UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JtOSp1ymWYGE4XqsByBkoln7JuwRprpXYlkSKLlRHr8='
WHERE
key_id = '9286f00d997564661dd582afa33aeb850d4b6b1f6a54162f7e985674527259bb'
AND (
token = 'JtOSp1ymWYGE4XqsByBkoln7JuwRprpXYlkSKLlRHr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)