UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8i0tt5y4/b/RU8FlessiLPEi1se++ZrSUI19JHQz0TU='
WHERE
key_id = 'aaa4c0dcb80a407ea940facee39f1d8ddbd092c4823a258bc0f182ac5d26cf3a'
AND (
token = '8i0tt5y4/b/RU8FlessiLPEi1se++ZrSUI19JHQz0TU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)