UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ExN/x+w2O8uQ2R0OhxPo9b3pCo3/kztXkp8ZXEMugQ='
WHERE
key_id = 'c167ffe557bd091cfea84e417ede937caca94007b2ddf4e3167d7f40d0b7d8ee'
AND (
token = '6ExN/x+w2O8uQ2R0OhxPo9b3pCo3/kztXkp8ZXEMugQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)