UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBSPrf02QyeuSiKhLLKkqumVDtlhKs7iGdbA5qxP+aI='
WHERE
key_id = '1c627c3d8aa70477097961e6b189123a70692a86ff0c2a1c9d861d77367b00f1'
AND (
token = 'XBSPrf02QyeuSiKhLLKkqumVDtlhKs7iGdbA5qxP+aI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)