UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CtrGIxdo7hVckYr2Y7B2sfwN/LAzG+ghX+MxsSsMryE='
WHERE
key_id = 'bc0e303c13a1bb4df3f421672f631e22dda15a21298daa0cfedf302e4cd0900e'
AND (
token = 'CtrGIxdo7hVckYr2Y7B2sfwN/LAzG+ghX+MxsSsMryE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)