UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yYF0g58qUMTVy1vUBFX5XiBY8/Q23lMycYEUUJCKIuo='
WHERE
key_id = 'ed7164521e9aceed6bb683dafacb55d43b51475301a75e350bef1fdd60ebe4f4'
AND (
token = 'yYF0g58qUMTVy1vUBFX5XiBY8/Q23lMycYEUUJCKIuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)