UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HN9BnGV1t+e3GwvczDXISiF0mtKLS+i4p4DtZqsxCRc='
WHERE
key_id = 'b1c2eef4ff560106eda7e258c811443c60647cec43b7bf359e7cb0053f02441a'
AND (
token = 'HN9BnGV1t+e3GwvczDXISiF0mtKLS+i4p4DtZqsxCRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)