UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lqkl3+1KC0fw5A1acmeSHbTi9UgvStCfVUjRx/MHdsc='
WHERE
key_id = '59539b1d7bd8196e87af93cec7ec711ac727fc9d943816991657114e0a47296b'
AND (
token = 'lqkl3+1KC0fw5A1acmeSHbTi9UgvStCfVUjRx/MHdsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)